Part of the original question by booby:
Was it not ultimately the decision Adam had to make; remain faithful and lose his soul mate, the love of his life (I would assume), or transgress to keep her and stand by her. And standing by her was a mandate of the marital vows, no?
Let's go along with the story of Adam & Eve for the sake of posterity. Adam had never met any other human. He had zero experience of life; the mentality of a 5 year old. He was bored, no TV, no books, no bible to study. Lonely, sex starved and unfulfilled.
Suddenly he is is given a present; a beautiful naked woman to play with. He's keen to please her, cos hell hath no fury like a woman scorned and even Adam would have quickly worked out this great truth of life. He stands by her and shows love, loyalty and gratefulness for his new toy - Eve.
God, who made the fruit trees, Adam & Eve, calls this sin and plunges the world into 6000 years of suffering and death because Adam ate an apple. He was too naive to firstly eat from the tree of life. We live and learn I guess. Or in Adams case we die and don't get a chance to learn.
What's the moral of this story. There isn't one!